const sequelize = require("../db");
const DataTypes = require("sequelize");

const Scores = sequelize.define("scores", {
  num: {
    type: DataTypes.INTEGER,
    comment: "序号"
  }, //成绩
  term: {
    type: DataTypes.STRING,
    comment: "学期"
  }, //成绩
  grade: {
    type: DataTypes.STRING,
    comment: "年级"
  }, //成绩
  classes: {
    type: DataTypes.STRING,
    comment: "班级"
  }, //成绩
  exam: {
    type: DataTypes.STRING,
    comment: "考试"
  }, //成绩
  subject: {
    type: DataTypes.STRING,
    comment: "科目"
  }, //成绩
  sNum: {
    type: DataTypes.STRING,
    comment: "学号"
  }, //成绩
  sName: {
    type: DataTypes.STRING,
    comment: "姓名"
  }, //成绩
  scores: {
    type: DataTypes.FLOAT,
    comment: "成绩"
  }, //成绩
  msg: {
    type: DataTypes.STRING,
    comment: "备注"
  }
});

module.exports = Scores;
